import pymysql

if __name__ == '__main__':
    conn = pymysql.connect(
        host='localhost',
        port=3306,
        user='root',
        passwd='lsc57478102',
        database='lsc-learn-python',
        charset='utf8'
    )

    cursor = conn.cursor()

    sql = """
        CREATE TABLE user_lsc (
            id INT auto_increment PRIMARY KEY,
            name CHAR(10) NOT NULL UNIQUE,
            age TINYINT NOT NULL
        );
        """

    cursor.execute(sql)